# -*- coding: utf-8 -*-
import xlrd,datetime
from xlrd import xldate_as_tuple,xldate_as_datetime
file = xlrd.open_workbook("D:\downloads\批量修改年假清零时间-模板 (3).xlsx")
sheet = file.sheet_by_name("Sheet3")
print(sheet.nrows,sheet.ncols)

list=[]
list1=[]
# for i in range(sheet.nrows):
#      list.append(sheet.row_values(i))
# print(list)

for i in range(1,sheet.nrows):
     list.append(sheet.row_values(i)[3])

print(list)
print(type(list))
l=[]
list2=sheet.col_values(0,start_rowx=1,end_rowx=sheet.nrows)
for i in list2:
     l.append(str(i).split(".")[0])
print(l)
# for i in list:
#      list1.append(xlrd.xldate_as_datetime(i,0).strftime("%Y/%m/%d"))
# print(list1)
